Create Fundamental Staging table and popuated with data - Conitued 10
*Using SSIS Toolbox, the
following components will be drag in the Control Flow Dashboard:
1.
Drag
and drop the Excel Source – Double click and add the excel connection
manager and select the sheet from the excel to load the data
2. Drag and drop the derived column - use the Derived column Code - Add Column to pouplate the Filename and name the soruce file name.
3. Drag
and drop the Conditional Split - Double click and add condition to remove the
Null values
ISNULL(MSA) || ISNULL(YEAR) || ISNULL(STOCK) || ISNULL(COMPL) ||
ISNULL(ABSORP) || ISNULL([VAC %]) || ISNULL([OCC %]) || ISNULL(RENT) ||
ISNULL(RI) || ISNULL([OCC SF]) || ISNULL(Low) || ISNULL(Model) || ISNULL(High)4. Drag and drop the Conditional Split - Double click and add condition to remove the Null values
5. Drag and drop the Data Conversion – and change the datatype
6. Drag and drop the Destination Source – Double click and add the OLE- DB connection manager and select the destination table
Repeat the Steps for all Fundamentals to load the rest of 3 table.
Populate the Fundamental Tables with data after executing the package.
https://zappysys.com/blog/read-excel-file-ssis-load-sql-server/